{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Carryover"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Carryover","index":0,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[[6,3,6,4],[6,6,6,7],[2,0,2,9],[3,1,3,3],[3,4,3,7],[4,3,4,7],[5,3,5,4],[5,6,5,7],[46,3,46,6],[42,3,42,6],[45,3,45,6],[12,6,12,8],[45,1,45,2],[42,1,42,2],[45,8,45,9],[43,3,43,6],[42,8,42,9],[13,6,13,7],[37,2,40,9],[17,6,17,7],[9,1,9,9],[8,1,8,9],[14,6,14,7],[15,6,15,7],[16,6,16,7],[10,1,10,9]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 09-Jun-2023. Last reviewed on 09-Jun-2023.\r\nVAL 2016 (version 1.0). Carryover Spreadsheet. Page 1 of 1"]
["Carryover Study"]
[null,"Method being evaluated:"]
[null,null,"Analyte:"]
[null,null,"Units:",null,null,"Date:"]
[null,null,"Low Conc.:",null,null,"High Conc.:"]
[]
["•","Choose a sample (H) with a very high concentration of the analyte, and a sample (L) with a very low concentration.\n"]
["•","Run eleven replicates of the low sample, and ten replicates of the high sample, in the following order: Do not run any other samples within the series"]
["•","A passing status is given if the Carryover is less than the Error Limit which is based upon three times the Low-Low SD."]
[]
[null,"Sample","Result","Low-Low","High-Low",null,"Analysis"]
[null,"L1",{"$nulls":4},"High - Low Mean:",null,{"$f":"E35","v":{"$error":"#DIV/0!"}}]
[null,"L2",null,{"$f":"IF(ISBLANK(C15),\" \",C15)","v":" "},null,null,"Low - Low Mean:",null,{"$f":"D35","v":{"$error":"#DIV/0!"}}]
[null,"L3",null,{"$f":"IF(ISBLANK(C16),\" \",C16)","v":" "},null,null,"Carryover:",null,{"$f":"I14-I15","v":{"$error":"#DIV/0!"}}]
[null,"H1",{"$nulls":4},"Error Limit:",null,{"$f":"D36*3","v":{"$error":"#DIV/0!"}}]
[null,"H2",{"$nulls":4},"Status:",null,{"$f":"IF(I16<=I17,\"PASS\",\"FAIL\")","v":{"$error":"#DIV/0!"}}]
[null,"L4",null,null,{"$f":"IF(ISBLANK(C19),\" \",C19)","v":" "}]
[null,"H3"]
[null,"H4"]
[null,"L5",null,null,{"$f":"IF(ISBLANK(C22),\" \",C22)","v":" "}]
[null,"L6",null,{"$f":"IF(ISBLANK(C23),\" \",C23)","v":" "}]
[null,"L7",null,{"$f":"IF(ISBLANK(C24),\" \",C24)","v":" "}]
[null,"L8",null,{"$f":"IF(ISBLANK(C25),\" \",C25)","v":" "}]
[null,"H5"]
[null,"H6"]
[null,"L9",null,null,{"$f":"IF(ISBLANK(C28),\" \",C28)","v":" "}]
[null,"H7"]
[null,"H8"]
[null,"L10",null,null,{"$f":"IF(ISBLANK(C31),\" \",C31)","v":" "}]
[null,"H9"]
[null,"H10"]
[null,"L11",null,null,{"$f":"IF(ISBLANK(C34),\" \",C34)","v":" "}]
[null,"Mean",null,{"$f":"AVERAGE(D14:D34)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E14:E34)","v":{"$error":"#DIV/0!"}}]
[null,"SD",null,{"$f":"STDEV(D14:D34)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(E14:E34)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Comment:"]
[]
[]
[]
[]
[null,"Analyst:",{"$nulls":5},"Date:"]
[]
[]
[null,"Accepted by:",{"$nulls":5},"Date:"]